<%@ page import="java.sql.*,studentportal.*"%>
<html>
</head>
</head>

<body>

<form method="POST" action="./feepaymentypedetails">
  <!--webbot bot="SaveResults" u-file="D:\Tomcat 5.0\webapps\Student\_private\form_results.csv" s-format="TEXT/CSV" s-label-fields="TRUE" --><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
    <tr>
      <td width="100%" colspan="2">
      <p align="center">Fee Payment Type Master Details</td>
    </tr>
    <tr>
      <td width="50%">Fee Payment Type ID</td>
    <td width="50%"><select size="1" name="fid" tabindex="1">
	  <%
	    Connection  con=MySQLDriver.getConnection();
	    Statement st=con.createStatement();
	    ResultSet rs=st.executeQuery("select fee_payment_type_id from fee_payment_type_master");
	  while(rs.next())
	  {
	  %>
	  <option><%=rs.getString(1)%></option>
	<%
	  }
		st.close();
		con.close();
	  %>
	  </select></td>
    </tr>
    <tr>
      <td width="50%">Fee Amount</td>
      <td width="50%"><input type="text" name="famt" size="20" tabindex="2"></td>
    </tr>
    <tr>
      <td width="50%">Fee Payment ID</td>
      <td width="50%"><select size="1" name="fptid" tabindex="3">
	  <%
	    Connection  con1=MySQLDriver.getConnection();
	    Statement st1=con1.createStatement();
	    ResultSet rs1=st.executeQuery("select fee_payment_id from fee_payment_master");
	  while(rs1.next())
	  {
	  %>
	  <option><%=rs1.getString(1)%></option>
	<%
	  }con.close();con1.close();
	  %>
	  </select></td>
    </tr>
    <tr>
      <td width="100%" colspan="2">
      <p align="center">
      <input type="submit" value="Insert" name="action" tabindex="4"><input type="submit" value="Delete" name="action" tabindex="5"><input type="submit" value="Search" name="action" tabindex="6"></td>
    </tr>
  </table>
</form>

</body>

</html>